﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="user01.aspx.cs" Inherits="utd_hrrs.user01" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
        Current Reservations<br />
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
            ConnectionString="<%$ ConnectionStrings:UTD_HRRSConnectionString %>" 
            onselecting="SqlDataSource2_Selecting" 
            
            
            SelectCommand="SELECT r.RESERV_ID, r.INV_ID, r.START_DATE, r.END_DATE, r.START_TIME, r.END_TIME, i.EQUIP_TYPE FROM RESERVATION r, INVENTORY i WHERE USER_ID='user01' AND GETDATE() &lt; START_DATE AND r.INV_ID=i.INV_ID  ORDER BY r.START_DATE">
        </asp:SqlDataSource>
        <br />
    
        <br />
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
            DataSourceID="SqlDataSource2" AllowPaging="True" AllowSorting="True">
            <Columns>
                <asp:BoundField DataField="EQUIP_TYPE" HeaderText="ITEM" 
                    SortExpression="EQUIP_TYPE" />
                <asp:BoundField DataField="START_DATE" HeaderText="START_DATE" 
                    SortExpression="START_DATE" />
                <asp:BoundField DataField="END_DATE" HeaderText="END_DATE" 
                    SortExpression="END_DATE" />
                <asp:BoundField DataField="START_TIME" HeaderText="START_TIME" 
                    SortExpression="START_TIME" />
                <asp:BoundField DataField="END_TIME" HeaderText="END_TIME" 
                    SortExpression="END_TIME" />

                <asp:ButtonField ButtonType="Button" CommandName="Remove" Text="Remove" />

            </Columns>
        </asp:GridView>
        <p style="margin-left: 40px">
        <br />
        <br />
        
        <br />
        <br />
    
        </p>
    
    </div>
    </form>
</body>
</html>
